package com.mhc.suzuki.dal.query;


import com.subaru.common.query.BaseCriteria;
import com.subaru.common.query.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public class CreditQueryApplyQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public CreditQueryApplyQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table pcl_credit_query_apply
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andCreditQueryApplyIdIsNull() {
            addCriterion("credit_query_apply_id is null");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdIsNotNull() {
            addCriterion("credit_query_apply_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdEqualTo(Long value) {
            addCriterion("credit_query_apply_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdNotEqualTo(Long value) {
            addCriterion("credit_query_apply_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anCreditQueryApplyIdGreaterThan(Long value) {
            addCriterion("credit_query_apply_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdGreaterThanOrEqualTo(Long value) {
            addCriterion("credit_query_apply_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdLessThan(Long value) {
            addCriterion("credit_query_apply_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdLessThanOrEqualTo(Long value) {
            addCriterion("credit_query_apply_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdIn(List<Long> values) {
            addCriterion("credit_query_apply_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdNotIn(List<Long> values) {
            addCriterion("credit_query_apply_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdBetween(Long value1, Long value2) {
            addCriterion("credit_query_apply_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreditQueryApplyIdNotBetween(Long value1, Long value2) {
            addCriterion("credit_query_apply_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDate value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDate value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDate value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDate value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDate> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDate> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDate value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDate value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDate value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDate value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDate> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDate> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(Long value) {
            addCriterion("customer_id =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(Long value) {
            addCriterion("customer_id <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(Long value) {
            addCriterion("customer_id >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("customer_id >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(Long value) {
            addCriterion("customer_id <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(Long value) {
            addCriterion("customer_id <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLike(Long value) {
            addCriterion("customer_id like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotLike(Long value) {
            addCriterion("customer_id not like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<Long> values) {
            addCriterion("customer_id in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<Long> values) {
            addCriterion("customer_id not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(Long value1, Long value2) {
            addCriterion("customer_id between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(Long value1, Long value2) {
            addCriterion("customer_id not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andBankIdIsNull() {
            addCriterion("bank_id is null");
            return (Criteria) this;
        }

        public Criteria andBankIdIsNotNull() {
            addCriterion("bank_id is not null");
            return (Criteria) this;
        }

        public Criteria andBankIdEqualTo(Long value) {
            addCriterion("bank_id =", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotEqualTo(Long value) {
            addCriterion("bank_id <>", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdGreaterThan(Long value) {
            addCriterion("bank_id >", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdGreaterThanOrEqualTo(Long value) {
            addCriterion("bank_id >=", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLessThan(Long value) {
            addCriterion("bank_id <", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLessThanOrEqualTo(Long value) {
            addCriterion("bank_id <=", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLike(Long value) {
            addCriterion("bank_id like", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotLike(Long value) {
            addCriterion("bank_id not like", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdIn(List<Long> values) {
            addCriterion("bank_id in", values, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotIn(List<Long> values) {
            addCriterion("bank_id not in", values, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdBetween(Long value1, Long value2) {
            addCriterion("bank_id between", value1, value2, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotBetween(Long value1, Long value2) {
            addCriterion("bank_id not between", value1, value2, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("bank_name is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("bank_name =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("bank_name <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("bank_name >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("bank_name >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("bank_name <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("bank_name <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("bank_name like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("bank_name not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("bank_name in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("bank_name not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("bank_name between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("bank_name not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andCreditResultIsNull() {
            addCriterion("credit_result is null");
            return (Criteria) this;
        }

        public Criteria andCreditResultIsNotNull() {
            addCriterion("credit_result is not null");
            return (Criteria) this;
        }

        public Criteria andCreditResultEqualTo(String value) {
            addCriterion("credit_result =", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultNotEqualTo(String value) {
            addCriterion("credit_result <>", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultGreaterThan(String value) {
            addCriterion("credit_result >", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultGreaterThanOrEqualTo(String value) {
            addCriterion("credit_result >=", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultLessThan(String value) {
            addCriterion("credit_result <", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultLessThanOrEqualTo(String value) {
            addCriterion("credit_result <=", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultLike(String value) {
            addCriterion("credit_result like", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultNotLike(String value) {
            addCriterion("credit_result not like", value, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultIn(List<String> values) {
            addCriterion("credit_result in", values, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultNotIn(List<String> values) {
            addCriterion("credit_result not in", values, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultBetween(String value1, String value2) {
            addCriterion("credit_result between", value1, value2, "creditResult");
            return (Criteria) this;
        }

        public Criteria andCreditResultNotBetween(String value1, String value2) {
            addCriterion("credit_result not between", value1, value2, "creditResult");
            return (Criteria) this;
        }

        public Criteria andQueryStatusIsNull() {
            addCriterion("query_status is null");
            return (Criteria) this;
        }

        public Criteria andQueryStatusIsNotNull() {
            addCriterion("query_status is not null");
            return (Criteria) this;
        }

        public Criteria andQueryStatusEqualTo(Integer value) {
            addCriterion("query_status =", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusNotEqualTo(Integer value) {
            addCriterion("query_status <>", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusGreaterThan(Integer value) {
            addCriterion("query_status >", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("query_status >=", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusLessThan(Integer value) {
            addCriterion("query_status <", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusLessThanOrEqualTo(Integer value) {
            addCriterion("query_status <=", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusLike(Integer value) {
            addCriterion("query_status like", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusNotLike(Integer value) {
            addCriterion("query_status not like", value, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusIn(List<Integer> values) {
            addCriterion("query_status in", values, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusNotIn(List<Integer> values) {
            addCriterion("query_status not in", values, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusBetween(Integer value1, Integer value2) {
            addCriterion("query_status between", value1, value2, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andQueryStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("query_status not between", value1, value2, "queryStatus");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Long value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Long value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Long value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Long value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(Long value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(Long value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Long> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Long> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Long value1, Long value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNull() {
            addCriterion("staff_name is null");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNotNull() {
            addCriterion("staff_name is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNameEqualTo(String value) {
            addCriterion("staff_name =", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotEqualTo(String value) {
            addCriterion("staff_name <>", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThan(String value) {
            addCriterion("staff_name >", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("staff_name >=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThan(String value) {
            addCriterion("staff_name <", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThanOrEqualTo(String value) {
            addCriterion("staff_name <=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLike(String value) {
            addCriterion("staff_name like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotLike(String value) {
            addCriterion("staff_name not like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameIn(List<String> values) {
            addCriterion("staff_name in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotIn(List<String> values) {
            addCriterion("staff_name not in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameBetween(String value1, String value2) {
            addCriterion("staff_name between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotBetween(String value1, String value2) {
            addCriterion("staff_name not between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdIsNull() {
            addCriterion("handle_staff_id is null");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdIsNotNull() {
            addCriterion("handle_staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdEqualTo(Long value) {
            addCriterion("handle_staff_id =", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotEqualTo(Long value) {
            addCriterion("handle_staff_id <>", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdGreaterThan(Long value) {
            addCriterion("handle_staff_id >", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("handle_staff_id >=", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdLessThan(Long value) {
            addCriterion("handle_staff_id <", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("handle_staff_id <=", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdLike(Long value) {
            addCriterion("handle_staff_id like", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotLike(Long value) {
            addCriterion("handle_staff_id not like", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdIn(List<Long> values) {
            addCriterion("handle_staff_id in", values, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotIn(List<Long> values) {
            addCriterion("handle_staff_id not in", values, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdBetween(Long value1, Long value2) {
            addCriterion("handle_staff_id between", value1, value2, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("handle_staff_id not between", value1, value2, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameIsNull() {
            addCriterion("handle_staff_name is null");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameIsNotNull() {
            addCriterion("handle_staff_name is not null");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameEqualTo(String value) {
            addCriterion("handle_staff_name =", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameNotEqualTo(String value) {
            addCriterion("handle_staff_name <>", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameGreaterThan(String value) {
            addCriterion("handle_staff_name >", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("handle_staff_name >=", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameLessThan(String value) {
            addCriterion("handle_staff_name <", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameLessThanOrEqualTo(String value) {
            addCriterion("handle_staff_name <=", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameLike(String value) {
            addCriterion("handle_staff_name like", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameNotLike(String value) {
            addCriterion("handle_staff_name not like", value, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameIn(List<String> values) {
            addCriterion("handle_staff_name in", values, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameNotIn(List<String> values) {
            addCriterion("handle_staff_name not in", values, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameBetween(String value1, String value2) {
            addCriterion("handle_staff_name between", value1, value2, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffNameNotBetween(String value1, String value2) {
            addCriterion("handle_staff_name not between", value1, value2, "handleStaffName");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNull() {
            addCriterion("dept_id is null");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNotNull() {
            addCriterion("dept_id is not null");
            return (Criteria) this;
        }

        public Criteria andDeptIdEqualTo(Long value) {
            addCriterion("dept_id =", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotEqualTo(Long value) {
            addCriterion("dept_id <>", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThan(Long value) {
            addCriterion("dept_id >", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThanOrEqualTo(Long value) {
            addCriterion("dept_id >=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThan(Long value) {
            addCriterion("dept_id <", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThanOrEqualTo(Long value) {
            addCriterion("dept_id <=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLike(Long value) {
            addCriterion("dept_id like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotLike(Long value) {
            addCriterion("dept_id not like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIn(List<Long> values) {
            addCriterion("dept_id in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotIn(List<Long> values) {
            addCriterion("dept_id not in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdBetween(Long value1, Long value2) {
            addCriterion("dept_id between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotBetween(Long value1, Long value2) {
            addCriterion("dept_id not between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptNameIsNull() {
            addCriterion("dept_name is null");
            return (Criteria) this;
        }

        public Criteria andDeptNameIsNotNull() {
            addCriterion("dept_name is not null");
            return (Criteria) this;
        }

        public Criteria andDeptNameEqualTo(String value) {
            addCriterion("dept_name =", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotEqualTo(String value) {
            addCriterion("dept_name <>", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThan(String value) {
            addCriterion("dept_name >", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThanOrEqualTo(String value) {
            addCriterion("dept_name >=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThan(String value) {
            addCriterion("dept_name <", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThanOrEqualTo(String value) {
            addCriterion("dept_name <=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLike(String value) {
            addCriterion("dept_name like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotLike(String value) {
            addCriterion("dept_name not like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameIn(List<String> values) {
            addCriterion("dept_name in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotIn(List<String> values) {
            addCriterion("dept_name not in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameBetween(String value1, String value2) {
            addCriterion("dept_name between", value1, value2, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotBetween(String value1, String value2) {
            addCriterion("dept_name not between", value1, value2, "deptName");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoIsNull() {
            addCriterion("annex_batch_no is null");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoIsNotNull() {
            addCriterion("annex_batch_no is not null");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoEqualTo(String value) {
            addCriterion("annex_batch_no =", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoNotEqualTo(String value) {
            addCriterion("annex_batch_no <>", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoGreaterThan(String value) {
            addCriterion("annex_batch_no >", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoGreaterThanOrEqualTo(String value) {
            addCriterion("annex_batch_no >=", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoLessThan(String value) {
            addCriterion("annex_batch_no <", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoLessThanOrEqualTo(String value) {
            addCriterion("annex_batch_no <=", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoLike(String value) {
            addCriterion("annex_batch_no like", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoNotLike(String value) {
            addCriterion("annex_batch_no not like", value, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoIn(List<String> values) {
            addCriterion("annex_batch_no in", values, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoNotIn(List<String> values) {
            addCriterion("annex_batch_no not in", values, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoBetween(String value1, String value2) {
            addCriterion("annex_batch_no between", value1, value2, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andAnnexBatchNoNotBetween(String value1, String value2) {
            addCriterion("annex_batch_no not between", value1, value2, "annexBatchNo");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNull() {
            addCriterion("record_time is null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNotNull() {
            addCriterion("record_time is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualTo(LocalDateTime value) {
            addCriterion("record_time =", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualTo(LocalDateTime value) {
            addCriterion("record_time <>", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThan(LocalDateTime value) {
            addCriterion("record_time >", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("record_time >=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThan(LocalDateTime value) {
            addCriterion("record_time <", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("record_time <=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLike(LocalDateTime value) {
            addCriterion("record_time like", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotLike(LocalDateTime value) {
            addCriterion("record_time not like", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIn(List<LocalDateTime> values) {
            addCriterion("record_time in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotIn(List<LocalDateTime> values) {
            addCriterion("record_time not in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("record_time between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("record_time not between", value1, value2, "recordTime");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table pcl_credit_query_apply
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}